/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-04-25 13:59:16
*/


-- ----------------------------
-- Table structure for tb3535
-- ----------------------------
DROP TABLE [dbo].[tb3535]
GO
CREATE TABLE [dbo].[tb3535] (
[TransactionID] varchar(20) NOT NULL ,
[EstimateID] varchar(50) NULL ,
[DivisionID] varchar(20) NULL ,
[TranMonth] int NULL ,
[TranYear] int NULL ,
[MaterialID] varchar(20) NULL ,
[MaterialQuantity] decimal(18,6) NULL ,
[MDescription] nvarchar(250) NULL ,
[Orders] int NULL ,
[WareHouseID] varchar(20) NULL ,
[IsPicking] tinyint NULL ,
[EDetailID] varchar(20) NULL ,
[UnitID] varchar(20) NULL ,
[ExpenseID] varchar(20) NULL ,
[MaterialTypeID] varchar(20) NULL ,
[ConvertedAmount] money NULL ,
[MaterialPrice] money NULL ,
[ConvertedUnit] money NULL ,
[QuantityUnit] decimal(28,8) NULL ,
[Num01] money NULL ,
[Num02] money NULL ,
[ProductID] varchar(20) NULL 
)


GO

-- ----------------------------
-- Records of tb3535
-- ----------------------------

-- ----------------------------
-- Indexes structure for table tb3535
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table tb3535
-- ----------------------------
ALTER TABLE [dbo].[tb3535] ADD PRIMARY KEY NONCLUSTERED ([TransactionID])
GO
